﻿CREATE TABLE [dbo].[User]
(
	[Id] BIGINT NOT NULL PRIMARY KEY IDENTITY, 
    [Login] NVARCHAR(50) NOT NULL, 
    [Password] NVARCHAR(50) NOT NULL, 
    [Salt] NVARCHAR(50) NOT NULL, 
    [Firstname] NVARCHAR(50) NOT NULL, 
    [Lastname] NVARCHAR(50) NOT NULL, 
    [AddDate] DATETIME NOT NULL, 
    [ModifyDate] DATETIME NULL, 
    [EntityState] TINYINT NOT NULL DEFAULT 0, 
    [EntityVersion] BIGINT NOT NULL DEFAULT 0
)
